package com.zoffy.wmsbackend.mapper;

import com.zoffy.wmsbackend.model.excel.bean.StockPurchaseVo;
import com.zoffy.wmsbackend.model.vo.stock.StockVO;
import com.zoffy.wmsbackend.model.entity.Stock;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


import java.util.List;

/**
* @author 86170
* @description 针对表【stock(库存表)】的数据库操作Mapper
* @createDate 2025-01-02 01:34:39
* @Entity com.zoffy.wmsbackend.modle.entity.Stock
*/
public interface StockMapper extends BaseMapper<Stock> {
    List<Stock> getStockByGoodIds(List<Long> goodIds);
    
    List<StockPurchaseVo> selectStockBelowSafeLevel();

    List<Stock> getStockByGoodIdsAndWarehouseId(@Param("goodIds") List<Long> goodIds, @Param("warehouseId") Long warehouseId);
    
    IPage<StockVO> selectStockPage(Page<StockVO> page, @Param("goodsCode") String goodsCode, @Param("goodsName") String goodsName,@Param("warehouseCode") String warehouseCode,@Param("warehouseName") String warehouseName,Integer  status);
}




